Dataset statistics
| Number of variables | 37 |
|---|---|
| Number of observations | 118434 |
| Missing cells | 26666 |
| Missing cells (%) | 0.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 38.4 MiB |
| Average record size in memory | 339.7 B |
Variable types
| Text | 8 |
|---|---|
| Numeric | 18 |
| Categorical | 5 |
| DateTime | 6 |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
payment_value is highly overall correlated with price | High correlation |
price is highly overall correlated with payment_value and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_weight_g is highly overall correlated with price and 3 other fields | High correlation |
product_width_cm is highly overall correlated with product_length_cm and 1 other fields | High correlation |
seller_state is highly overall correlated with seller_zip_code_prefix | High correlation |
seller_zip_code_prefix is highly overall correlated with seller_state | High correlation |
order_status is highly imbalanced (91.6%) | Imbalance |
payment_type is highly imbalanced (52.6%) | Imbalance |
seller_state is highly imbalanced (63.2%) | Imbalance |
order_delivered_carrier_date has 2074 (1.8%) missing values | Missing |
order_delivered_customer_date has 3397 (2.9%) missing values | Missing |
product_name_lenght has 2528 (2.1%) missing values | Missing |
product_description_lenght has 2528 (2.1%) missing values | Missing |
product_photos_qty has 2528 (2.1%) missing values | Missing |
product_category has 2553 (2.2%) missing values | Missing |
order_purchase_hour has 2910 (2.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-05 15:33:56.166358 |
|---|---|
| Analysis finished | 2024-08-05 15:35:41.853676 |
| Duration | 1 minute and 45.69 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
customer_id
Text
| Distinct | 99441 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3789888 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 86952 ? |
|---|---|
| Unique (%) | 73.4% |
Sample
| 1st row | 06b8999e2fba1a1fbc88172c00ba8bc7 |
|---|---|
| 2nd row | 18955e83d337fd6b2def6b18a428ac77 |
| 3rd row | 4e7b3e00288586ebd08712fdd0374a03 |
| 4th row | b2b6027bc5c5109e529d4dc6358b12c3 |
| 5th row | 4f2d8ab171c80ec8364f7c12e35b23ad |
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| b246eeed30b362c09d867b9e598bee51 | 22 | < 0.1% |
| 5e0f7317756669ff7b384444dbb81fa3 | 21 | < 0.1% |
| Other values (99431) | 118139 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 237574 | 6.3% |
| 2 | 237529 | 6.3% |
| 5 | 237365 | 6.3% |
| c | 237224 | 6.3% |
| 6 | 237112 | 6.3% |
| 1 | 237092 | 6.3% |
| 8 | 236965 | 6.3% |
| d | 236915 | 6.3% |
| a | 236874 | 6.3% |
| 7 | 236840 | 6.2% |
| Other values (6) | 1418398 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2367827 | |
| Lowercase Letter | 1422061 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 237529 | |
| 5 | 237365 | |
| 6 | 237112 | |
| 1 | 237092 | |
| 8 | 236965 | |
| 7 | 236840 | |
| 3 | 236818 | |
| 9 | 236542 | |
| 4 | 235900 | |
| 0 | 235664 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 237574 | |
| c | 237224 | |
| d | 236915 | |
| a | 236874 | |
| b | 236757 | |
| e | 236717 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2367827 | |
| Latin | 1422061 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 237529 | |
| 5 | 237365 | |
| 6 | 237112 | |
| 1 | 237092 | |
| 8 | 236965 | |
| 7 | 236840 | |
| 3 | 236818 | |
| 9 | 236542 | |
| 4 | 235900 | |
| 0 | 235664 |
Latin
| Value | Count | Frequency (%) |
| f | 237574 | |
| c | 237224 | |
| d | 236915 | |
| a | 236874 | |
| b | 236757 | |
| e | 236717 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3789888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| f | 237574 | 6.3% |
| 2 | 237529 | 6.3% |
| 5 | 237365 | 6.3% |
| c | 237224 | 6.3% |
| 6 | 237112 | 6.3% |
| 1 | 237092 | 6.3% |
| 8 | 236965 | 6.3% |
| d | 236915 | 6.3% |
| a | 236874 | 6.3% |
| 7 | 236840 | 6.2% |
| Other values (6) | 1418398 |
| Distinct | 96096 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3789888 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 81671 ? |
|---|---|
| Unique (%) | 69.0% |
Sample
| 1st row | 861eff4711a542e4b93843c6dd7febb0 |
|---|---|
| 2nd row | 290c77bc529b7ac935b93aa66c333dc3 |
| 3rd row | 060e732b5b29e8181a18229c7b0b2b5e |
| 4th row | 259dac757896d24d7702b9acbbff3f3c |
| 5th row | 345ecd01c38d18a9036ed96c73b8d066 |
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| 5419a7c9b86a43d8140e2939cd2c2f7e | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 2524dcec233c3766f2c2b22f69fd65f4 | 22 | < 0.1% |
| Other values (96086) | 118113 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 237846 | 6.3% |
| b | 237438 | 6.3% |
| 1 | 237367 | 6.3% |
| a | 237304 | 6.3% |
| d | 237140 | 6.3% |
| 3 | 237130 | 6.3% |
| 8 | 237023 | 6.3% |
| 2 | 236840 | 6.2% |
| 5 | 236810 | 6.2% |
| e | 236743 | 6.2% |
| Other values (6) | 1418247 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2368540 | |
| Lowercase Letter | 1421348 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 237846 | |
| 1 | 237367 | |
| 3 | 237130 | |
| 8 | 237023 | |
| 2 | 236840 | |
| 5 | 236810 | |
| 9 | 236734 | |
| 0 | 236475 | |
| 7 | 236468 | |
| 4 | 235847 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 237438 | |
| a | 237304 | |
| d | 237140 | |
| e | 236743 | |
| f | 236629 | |
| c | 236094 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2368540 | |
| Latin | 1421348 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 237846 | |
| 1 | 237367 | |
| 3 | 237130 | |
| 8 | 237023 | |
| 2 | 236840 | |
| 5 | 236810 | |
| 9 | 236734 | |
| 0 | 236475 | |
| 7 | 236468 | |
| 4 | 235847 |
Latin
| Value | Count | Frequency (%) |
| b | 237438 | |
| a | 237304 | |
| d | 237140 | |
| e | 236743 | |
| f | 236629 | |
| c | 236094 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3789888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 237846 | 6.3% |
| b | 237438 | 6.3% |
| 1 | 237367 | 6.3% |
| a | 237304 | 6.3% |
| d | 237140 | 6.3% |
| 3 | 237130 | 6.3% |
| 8 | 237023 | 6.3% |
| 2 | 236840 | 6.2% |
| 5 | 236810 | 6.2% |
| e | 236743 | 6.2% |
| Other values (6) | 1418247 |
customer_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 14994 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35034.264 |
| Minimum | 1003 |
|---|---|
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3275 |
| Q1 | 11310 |
| median | 24240 |
| Q3 | 58464.5 |
| 95-th percentile | 90560 |
| Maximum | 99990 |
| Range | 98987 |
| Interquartile range (IQR) | 47154.5 |
Descriptive statistics
| Standard deviation | 29819.29 |
|---|---|
| Coefficient of variation (CV) | 0.85114646 |
| Kurtosis | -0.78080429 |
| Mean | 35034.264 |
| Median Absolute Deviation (MAD) | 16230 |
| Skewness | 0.78547825 |
| Sum | 4.1492481 × 109 |
| Variance | 8.8919007 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 161 | 0.1% |
| 22790 | 155 | 0.1% |
| 22793 | 154 | 0.1% |
| 24230 | 138 | 0.1% |
| 22775 | 129 | 0.1% |
| 35162 | 124 | 0.1% |
| 29101 | 119 | 0.1% |
| 11740 | 111 | 0.1% |
| 13087 | 106 | 0.1% |
| 38400 | 106 | 0.1% |
| Other values (14984) | 117131 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 4 | |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 3 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99990 | 1 | < 0.1% |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 2 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
customer_city
Text
| Distinct | 4119 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.335622 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1224089 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1037 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | franca |
|---|---|
| 2nd row | sao bernardo do campo |
| 3rd row | sao paulo |
| 4th row | mogi das cruzes |
| 5th row | campinas |
| Value | Count | Frequency (%) |
| sao | 25280 | 12.2% |
| paulo | 18820 | 9.1% |
| de | 11576 | 5.6% |
| rio | 9902 | 4.8% |
| janeiro | 8252 | 4.0% |
| do | 5072 | 2.4% |
| belo | 3346 | 1.6% |
| horizonte | 3300 | 1.6% |
| brasilia | 2483 | 1.2% |
| porto | 1984 | 1.0% |
| Other values (3285) | 117718 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 201908 | |
| o | 151033 | |
| i | 93579 | 7.6% |
| r | 90680 | 7.4% |
| 89299 | 7.3% | |
| e | 79475 | 6.5% |
| s | 75013 | 6.1% |
| n | 54237 | 4.4% |
| u | 53750 | 4.4% |
| l | 53333 | 4.4% |
| Other values (21) | 281782 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1134240 | |
| Space Separator | 89299 | 7.3% |
| Dash Punctuation | 286 | < 0.1% |
| Other Punctuation | 262 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 201908 | |
| o | 151033 | |
| i | 93579 | 8.3% |
| r | 90680 | 8.0% |
| e | 79475 | 7.0% |
| s | 75013 | 6.6% |
| n | 54237 | 4.8% |
| u | 53750 | 4.7% |
| l | 53333 | 4.7% |
| p | 44505 | 3.9% |
| Other values (16) | 236727 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 89299 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 286 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 262 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1134240 | |
| Common | 89849 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 201908 | |
| o | 151033 | |
| i | 93579 | 8.3% |
| r | 90680 | 8.0% |
| e | 79475 | 7.0% |
| s | 75013 | 6.6% |
| n | 54237 | 4.8% |
| u | 53750 | 4.7% |
| l | 53333 | 4.7% |
| p | 44505 | 3.9% |
| Other values (16) | 236727 |
Common
| Value | Count | Frequency (%) |
| 89299 | ||
| - | 286 | 0.3% |
| ' | 262 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1224089 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 201908 | |
| o | 151033 | |
| i | 93579 | 7.6% |
| r | 90680 | 7.4% |
| 89299 | 7.3% | |
| e | 79475 | 6.5% |
| s | 75013 | 6.1% |
| n | 54237 | 4.4% |
| u | 53750 | 4.4% |
| l | 53333 | 4.4% |
| Other values (21) | 281782 |
customer_state
Categorical
HIGH CORRELATION 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 236868 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 49967 | |
| RJ | 15420 | 13.0% |
| MG | 13738 | 11.6% |
| RS | 6521 | 5.5% |
| PR | 6017 | 5.1% |
| SC | 4328 | 3.7% |
| BA | 4071 | 3.4% |
| DF | 2489 | 2.1% |
| GO | 2443 | 2.1% |
| ES | 2347 | 2.0% |
| Other values (17) | 11093 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 49967 | |
| rj | 15420 | 13.0% |
| mg | 13738 | 11.6% |
| rs | 6521 | 5.5% |
| pr | 6017 | 5.1% |
| sc | 4328 | 3.7% |
| ba | 4071 | 3.4% |
| df | 2489 | 2.1% |
| go | 2443 | 2.1% |
| es | 2347 | 2.0% |
| Other values (17) | 11093 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 64415 | |
| P | 60302 | |
| R | 28926 | |
| M | 16739 | 7.1% |
| G | 16181 | 6.8% |
| J | 15420 | 6.5% |
| A | 6855 | 2.9% |
| E | 6204 | 2.6% |
| C | 5983 | 2.5% |
| B | 4714 | 2.0% |
| Other values (7) | 11129 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 236868 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 64415 | |
| P | 60302 | |
| R | 28926 | |
| M | 16739 | 7.1% |
| G | 16181 | 6.8% |
| J | 15420 | 6.5% |
| A | 6855 | 2.9% |
| E | 6204 | 2.6% |
| C | 5983 | 2.5% |
| B | 4714 | 2.0% |
| Other values (7) | 11129 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 236868 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 64415 | |
| P | 60302 | |
| R | 28926 | |
| M | 16739 | 7.1% |
| G | 16181 | 6.8% |
| J | 15420 | 6.5% |
| A | 6855 | 2.9% |
| E | 6204 | 2.6% |
| C | 5983 | 2.5% |
| B | 4714 | 2.0% |
| Other values (7) | 11129 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 236868 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 64415 | |
| P | 60302 | |
| R | 28926 | |
| M | 16739 | 7.1% |
| G | 16181 | 6.8% |
| J | 15420 | 6.5% |
| A | 6855 | 2.9% |
| E | 6204 | 2.6% |
| C | 5983 | 2.5% |
| B | 4714 | 2.0% |
| Other values (7) | 11129 | 4.7% |
order_id
Text
| Distinct | 99441 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3789888 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 86952 ? |
|---|---|
| Unique (%) | 73.4% |
Sample
| 1st row | 00e7ee1b050b8499577073aeb2a297a1 |
|---|---|
| 2nd row | 29150127e6685892b6eab3eec79f59c7 |
| 3rd row | b2059ed67ce144a36e2aa97d2c9e9ad2 |
| 4th row | 951670f92359f4fe4a63112aa7306eba |
| 5th row | 6b7d50bd145f6fc7f33cebabd7e49d0f |
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| 285c2e15bebd4ac83635ccc563dc71f4 | 22 | < 0.1% |
| 958c6a70e60365b576dd696ad29bbca2 | 21 | < 0.1% |
| Other values (99431) | 118139 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 237976 | 6.3% |
| b | 237895 | 6.3% |
| 6 | 237797 | 6.3% |
| e | 237449 | 6.3% |
| 3 | 237239 | 6.3% |
| 8 | 237121 | 6.3% |
| c | 237072 | 6.3% |
| 7 | 237053 | 6.3% |
| 1 | 237035 | 6.3% |
| a | 236741 | 6.2% |
| Other values (6) | 1416510 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2368219 | |
| Lowercase Letter | 1421669 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 237976 | |
| 6 | 237797 | |
| 3 | 237239 | |
| 8 | 237121 | |
| 7 | 237053 | |
| 1 | 237035 | |
| 2 | 236488 | |
| 9 | 236349 | |
| 0 | 235705 | |
| 5 | 235456 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 237895 | |
| e | 237449 | |
| c | 237072 | |
| a | 236741 | |
| f | 236462 | |
| d | 236050 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2368219 | |
| Latin | 1421669 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 237976 | |
| 6 | 237797 | |
| 3 | 237239 | |
| 8 | 237121 | |
| 7 | 237053 | |
| 1 | 237035 | |
| 2 | 236488 | |
| 9 | 236349 | |
| 0 | 235705 | |
| 5 | 235456 |
Latin
| Value | Count | Frequency (%) |
| b | 237895 | |
| e | 237449 | |
| c | 237072 | |
| a | 236741 | |
| f | 236462 | |
| d | 236050 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3789888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 237976 | 6.3% |
| b | 237895 | 6.3% |
| 6 | 237797 | 6.3% |
| e | 237449 | 6.3% |
| 3 | 237239 | 6.3% |
| 8 | 237121 | 6.3% |
| c | 237072 | 6.3% |
| 7 | 237053 | 6.3% |
| 1 | 237035 | 6.3% |
| a | 236741 | 6.2% |
| Other values (6) | 1416510 |
order_status
Categorical
IMBALANCE 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| delivered | |
|---|---|
| shipped | 1245 |
| canceled | 745 |
| unavailable | 650 |
| processing | 375 |
| Other values (3) | 381 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9835689 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1063960 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 115038 | |
| shipped | 1245 | 1.1% |
| canceled | 745 | 0.6% |
| unavailable | 650 | 0.5% |
| processing | 375 | 0.3% |
| invoiced | 373 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 115038 | |
| shipped | 1245 | 1.1% |
| canceled | 745 | 0.6% |
| unavailable | 650 | 0.5% |
| processing | 375 | 0.3% |
| invoiced | 373 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 349260 | |
| d | 232447 | |
| i | 118054 | 11.1% |
| l | 117083 | 11.0% |
| v | 116064 | 10.9% |
| r | 115421 | 10.8% |
| p | 2871 | 0.3% |
| a | 2703 | 0.3% |
| c | 2243 | 0.2% |
| n | 2143 | 0.2% |
| Other values (7) | 5671 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1063960 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 349260 | |
| d | 232447 | |
| i | 118054 | 11.1% |
| l | 117083 | 11.0% |
| v | 116064 | 10.9% |
| r | 115421 | 10.8% |
| p | 2871 | 0.3% |
| a | 2703 | 0.3% |
| c | 2243 | 0.2% |
| n | 2143 | 0.2% |
| Other values (7) | 5671 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1063960 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 349260 | |
| d | 232447 | |
| i | 118054 | 11.1% |
| l | 117083 | 11.0% |
| v | 116064 | 10.9% |
| r | 115421 | 10.8% |
| p | 2871 | 0.3% |
| a | 2703 | 0.3% |
| c | 2243 | 0.2% |
| n | 2143 | 0.2% |
| Other values (7) | 5671 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1063960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 349260 | |
| d | 232447 | |
| i | 118054 | 11.1% |
| l | 117083 | 11.0% |
| v | 116064 | 10.9% |
| r | 115421 | 10.8% |
| p | 2871 | 0.3% |
| a | 2703 | 0.3% |
| c | 2243 | 0.2% |
| n | 2143 | 0.2% |
| Other values (7) | 5671 | 0.5% |
| Distinct | 98875 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| Minimum | 2016-09-04 21:15:19 |
|---|---|
| Maximum | 2018-10-17 17:30:18 |
| Distinct | 90733 |
|---|---|
| Distinct (%) | 76.7% |
| Missing | 176 |
| Missing (%) | 0.1% |
| Memory size | 5.8 MiB |
| Minimum | 2016-09-15 12:16:38 |
|---|---|
| Maximum | 2018-09-03 17:40:06 |
order_delivered_carrier_date
Date
MISSING 
| Distinct | 81018 |
|---|---|
| Distinct (%) | 69.6% |
| Missing | 2074 |
| Missing (%) | 1.8% |
| Memory size | 5.8 MiB |
| Minimum | 2016-10-08 10:34:01 |
|---|---|
| Maximum | 2018-09-11 19:48:28 |
order_delivered_customer_date
Date
MISSING 
| Distinct | 95664 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 3397 |
| Missing (%) | 2.9% |
| Memory size | 5.8 MiB |
| Minimum | 2016-10-11 13:46:32 |
|---|---|
| Maximum | 2018-10-17 13:22:46 |
| Distinct | 459 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| Minimum | 2016-09-30 00:00:00 |
|---|---|
| Maximum | 2018-11-12 00:00:00 |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1959202 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.69772067 |
|---|---|
| Coefficient of variation (CV) | 0.58341741 |
| Kurtosis | 104.20293 |
| Mean | 1.1959202 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.5710461 |
| Sum | 140645 |
| Variance | 0.48681413 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103057 | |
| 2 | 10239 | 8.6% |
| 3 | 2376 | 2.0% |
| 4 | 986 | 0.8% |
| 5 | 469 | 0.4% |
| 6 | 262 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 66 | 0.1% |
| (Missing) | 830 | 0.7% |
| Value | Count | Frequency (%) |
| 1 | 103057 | |
| 2 | 10239 | 8.6% |
| 3 | 2376 | 2.0% |
| 4 | 986 | 0.8% |
| 5 | 469 | 0.4% |
| 6 | 262 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
product_id
Text
| Distinct | 32951 |
|---|---|
| Distinct (%) | 28.0% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3763328 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17444 ? |
|---|---|
| Unique (%) | 14.8% |
Sample
| 1st row | a9516a079e37a9c9c36b9b78b10169e8 |
|---|---|
| 2nd row | 4aa6014eceb682077f9dc4bffebc05b0 |
| 3rd row | bd07b66896d6f1494f5b86251848ced7 |
| 4th row | a5647c44af977b148e0a3a4751a09e2e |
| 5th row | 9391a573abe00141c56e38d84d7d5b3b |
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 525 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 505 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 406 | 0.3% |
| 368c6c730842d78016ad823897a372db | 395 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 357 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 327 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 283 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 278 | 0.2% |
| Other values (32941) | 113603 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 241732 | 6.4% |
| 9 | 239628 | 6.4% |
| e | 237452 | 6.3% |
| 8 | 236819 | 6.3% |
| 7 | 236771 | 6.3% |
| 4 | 236040 | 6.3% |
| a | 235924 | 6.3% |
| c | 234931 | 6.2% |
| 0 | 234839 | 6.2% |
| 2 | 234705 | 6.2% |
| Other values (6) | 1394487 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2361683 | |
| Lowercase Letter | 1401645 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 241732 | |
| 9 | 239628 | |
| 8 | 236819 | |
| 7 | 236771 | |
| 4 | 236040 | |
| 0 | 234839 | |
| 2 | 234705 | |
| 6 | 234263 | |
| 5 | 234216 | |
| 1 | 232670 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 237452 | |
| a | 235924 | |
| c | 234931 | |
| b | 233596 | |
| d | 231370 | |
| f | 228372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2361683 | |
| Latin | 1401645 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 241732 | |
| 9 | 239628 | |
| 8 | 236819 | |
| 7 | 236771 | |
| 4 | 236040 | |
| 0 | 234839 | |
| 2 | 234705 | |
| 6 | 234263 | |
| 5 | 234216 | |
| 1 | 232670 |
Latin
| Value | Count | Frequency (%) |
| e | 237452 | |
| a | 235924 | |
| c | 234931 | |
| b | 233596 | |
| d | 231370 | |
| f | 228372 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3763328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 241732 | 6.4% |
| 9 | 239628 | 6.4% |
| e | 237452 | 6.3% |
| 8 | 236819 | 6.3% |
| 7 | 236771 | 6.3% |
| 4 | 236040 | 6.3% |
| a | 235924 | 6.3% |
| c | 234931 | 6.2% |
| 0 | 234839 | 6.2% |
| 2 | 234705 | 6.2% |
| Other values (6) | 1394487 |
seller_id
Text
| Distinct | 3095 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Memory size | 5.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3763328 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 491 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 7c67e1448b00f6e969d365cea6b010ab |
|---|---|
| 2nd row | b8bc237ba3788b23da09c0f1f3a3288c |
| 3rd row | 7c67e1448b00f6e969d365cea6b010ab |
| 4th row | 7c67e1448b00f6e969d365cea6b010ab |
| 5th row | 4a3ca9315b744ce9f8e9374361493884 |
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2133 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2122 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2008 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1847 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1639 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1528 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1462 | 1.2% |
| 7c67e1448b00f6e969d365cea6b010ab | 1452 | 1.2% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1240 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1239 | 1.1% |
| Other values (3085) | 100934 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 255271 | 6.8% |
| c | 248272 | 6.6% |
| 4 | 246945 | 6.6% |
| 6 | 242188 | 6.4% |
| 0 | 241220 | 6.4% |
| a | 239844 | 6.4% |
| b | 239238 | 6.4% |
| 3 | 239187 | 6.4% |
| 9 | 233721 | 6.2% |
| 2 | 232497 | 6.2% |
| Other values (6) | 1344945 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2380420 | |
| Lowercase Letter | 1382908 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 255271 | |
| 4 | 246945 | |
| 6 | 242188 | |
| 0 | 241220 | |
| 3 | 239187 | |
| 9 | 233721 | |
| 2 | 232497 | |
| 8 | 230272 | |
| 5 | 229725 | |
| 7 | 229394 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 248272 | |
| a | 239844 | |
| b | 239238 | |
| e | 221358 | |
| f | 217994 | |
| d | 216202 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2380420 | |
| Latin | 1382908 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 255271 | |
| 4 | 246945 | |
| 6 | 242188 | |
| 0 | 241220 | |
| 3 | 239187 | |
| 9 | 233721 | |
| 2 | 232497 | |
| 8 | 230272 | |
| 5 | 229725 | |
| 7 | 229394 |
Latin
| Value | Count | Frequency (%) |
| c | 248272 | |
| a | 239844 | |
| b | 239238 | |
| e | 221358 | |
| f | 217994 | |
| d | 216202 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3763328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 255271 | 6.8% |
| c | 248272 | 6.6% |
| 4 | 246945 | 6.6% |
| 6 | 242188 | 6.4% |
| 0 | 241220 | 6.4% |
| a | 239844 | 6.4% |
| b | 239238 | 6.4% |
| 3 | 239187 | 6.4% |
| 9 | 233721 | 6.2% |
| 2 | 232497 | 6.2% |
| Other values (6) | 1344945 |
| Distinct | 93318 |
|---|---|
| Distinct (%) | 79.3% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Memory size | 5.8 MiB |
| Minimum | 2016-09-19 00:15:34 |
|---|---|
| Maximum | 2020-04-09 22:35:08 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 5968 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.82285 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 184.47737 |
|---|---|
| Coefficient of variation (CV) | 1.5268417 |
| Kurtosis | 118.86346 |
| Mean | 120.82285 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.8857991 |
| Sum | 14209250 |
| Variance | 34031.899 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2606 | 2.2% |
| 69.9 | 2092 | 1.8% |
| 49.9 | 2045 | 1.7% |
| 89.9 | 1623 | 1.4% |
| 99.9 | 1510 | 1.3% |
| 39.9 | 1395 | 1.2% |
| 29.9 | 1378 | 1.2% |
| 19.9 | 1279 | 1.1% |
| 79.9 | 1276 | 1.1% |
| 29.99 | 1221 | 1.0% |
| Other values (5958) | 101179 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6999 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.045551 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 390 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.29 |
| Q3 | 21.19 |
| 95-th percentile | 45.3 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.11 |
Descriptive statistics
| Standard deviation | 15.861351 |
|---|---|
| Coefficient of variation (CV) | 0.79126539 |
| Kurtosis | 57.583093 |
| Mean | 20.045551 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5429427 |
| Sum | 2357437 |
| Variance | 251.58245 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3831 | 3.2% |
| 7.78 | 2339 | 2.0% |
| 11.85 | 1972 | 1.7% |
| 14.1 | 1971 | 1.7% |
| 18.23 | 1625 | 1.4% |
| 7.39 | 1568 | 1.3% |
| 16.11 | 1194 | 1.0% |
| 15.23 | 1061 | 0.9% |
| 8.72 | 964 | 0.8% |
| 16.79 | 924 | 0.8% |
| Other values (6989) | 100155 |
| Value | Count | Frequency (%) |
| 0 | 390 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
payment_sequential
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0942068 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7282895 |
|---|---|
| Coefficient of variation (CV) | 0.66558674 |
| Kurtosis | 346.64585 |
| Mean | 1.0942068 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.881705 |
| Sum | 129588 |
| Variance | 0.5304056 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 113332 | |
| 2 | 3397 | 2.9% |
| 3 | 651 | 0.5% |
| 4 | 318 | 0.3% |
| 5 | 191 | 0.2% |
| 6 | 134 | 0.1% |
| 7 | 92 | 0.1% |
| 8 | 61 | 0.1% |
| 9 | 50 | < 0.1% |
| 10 | 41 | < 0.1% |
| Other values (19) | 164 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 113332 | |
| 2 | 3397 | 2.9% |
| 3 | 651 | 0.5% |
| 4 | 318 | 0.3% |
| 5 | 191 | 0.2% |
| 6 | 134 | 0.1% |
| 7 | 92 | 0.1% |
| 8 | 61 | 0.1% |
| 9 | 50 | < 0.1% |
| 10 | 41 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 5.8 MiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6407 |
| debit_card | 1698 |
| not_defined | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.7966749 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1160230 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | credit_card |
| 3rd row | credit_card |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 87286 | |
| boleto | 23037 | 19.5% |
| voucher | 6407 | 5.4% |
| debit_card | 1698 | 1.4% |
| not_defined | 3 | < 0.1% |
| (Missing) | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit_card | 87286 | |
| boleto | 23037 | 19.5% |
| voucher | 6407 | 5.4% |
| debit_card | 1698 | 1.4% |
| not_defined | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 182677 | |
| r | 182677 | |
| d | 177974 | |
| e | 118434 | |
| t | 112024 | |
| i | 88987 | |
| _ | 88987 | |
| a | 88984 | |
| o | 52484 | 4.5% |
| b | 24735 | 2.1% |
| Other values (6) | 42267 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1071243 | |
| Connector Punctuation | 88987 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 182677 | |
| r | 182677 | |
| d | 177974 | |
| e | 118434 | |
| t | 112024 | |
| i | 88987 | |
| a | 88984 | |
| o | 52484 | 4.9% |
| b | 24735 | 2.3% |
| l | 23037 | 2.2% |
| Other values (5) | 19230 | 1.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 88987 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1071243 | |
| Common | 88987 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 182677 | |
| r | 182677 | |
| d | 177974 | |
| e | 118434 | |
| t | 112024 | |
| i | 88987 | |
| a | 88984 | |
| o | 52484 | 4.9% |
| b | 24735 | 2.3% |
| l | 23037 | 2.2% |
| Other values (5) | 19230 | 1.8% |
Common
| Value | Count | Frequency (%) |
| _ | 88987 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1160230 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 182677 | |
| r | 182677 | |
| d | 177974 | |
| e | 118434 | |
| t | 112024 | |
| i | 88987 | |
| _ | 88987 | |
| a | 88984 | |
| o | 52484 | 4.5% |
| b | 24735 | 2.1% |
| Other values (6) | 42267 | 3.6% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9373981 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7741644 |
|---|---|
| Coefficient of variation (CV) | 0.94442914 |
| Kurtosis | 2.5218464 |
| Mean | 2.9373981 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6227641 |
| Sum | 347879 |
| Variance | 7.6959881 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 59117 | |
| 2 | 13794 | 11.6% |
| 3 | 11814 | 10.0% |
| 4 | 8027 | 6.8% |
| 10 | 6899 | 5.8% |
| 5 | 6056 | 5.1% |
| 8 | 5077 | 4.3% |
| 6 | 4638 | 3.9% |
| 7 | 1839 | 1.6% |
| 9 | 735 | 0.6% |
| Other values (14) | 435 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 59117 | |
| 2 | 13794 | 11.6% |
| 3 | 11814 | 10.0% |
| 4 | 8027 | 6.8% |
| 5 | 6056 | 5.1% |
| 6 | 4638 | 3.9% |
| 7 | 1839 | 1.6% |
| 8 | 5077 | 4.3% |
| 9 | 735 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 5 | < 0.1% |
| 20 | 21 | < 0.1% |
| 18 | 38 | |
| 17 | 8 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 92 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 29077 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.84939 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.18 |
| Q1 | 60.86 |
| median | 108.2 |
| Q3 | 189.245 |
| 95-th percentile | 515.94 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.385 |
Descriptive statistics
| Standard deviation | 268.25983 |
|---|---|
| Coefficient of variation (CV) | 1.5519859 |
| Kurtosis | 499.70102 |
| Mean | 172.84939 |
| Median Absolute Deviation (MAD) | 56.63 |
| Skewness | 13.969151 |
| Sum | 20470727 |
| Variance | 71963.337 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 351 | 0.3% |
| 100 | 300 | 0.3% |
| 20 | 286 | 0.2% |
| 77.57 | 250 | 0.2% |
| 35 | 166 | 0.1% |
| 73.34 | 160 | 0.1% |
| 30 | 139 | 0.1% |
| 116.94 | 131 | 0.1% |
| 56.78 | 123 | 0.1% |
| 65 | 119 | 0.1% |
| Other values (29067) | 116406 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | < 0.1% |
| 0.11 | 2 | < 0.1% |
| 0.13 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6922.21 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
product_name_lenght
Real number (ℝ)
MISSING 
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2528 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.767208 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.035162 |
|---|---|
| Coefficient of variation (CV) | 0.20577685 |
| Kurtosis | 0.15160625 |
| Mean | 48.767208 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90552833 |
| Sum | 5652412 |
| Variance | 100.70448 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8630 | 7.3% |
| 60 | 8030 | 6.8% |
| 56 | 6797 | 5.7% |
| 58 | 6776 | 5.7% |
| 57 | 6271 | 5.3% |
| 55 | 5797 | 4.9% |
| 54 | 5489 | 4.6% |
| 53 | 4338 | 3.7% |
| 52 | 4296 | 3.6% |
| 49 | 3665 | 3.1% |
| Other values (56) | 55817 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 15 | < 0.1% |
| 10 | 9 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 38 | |
| 13 | 26 | |
| 14 | 47 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 2 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 171 | 0.1% |
| 63 | 1344 | |
| 62 | 163 | 0.1% |
| 61 | 241 | 0.2% |
product_description_lenght
Real number (ℝ)
MISSING 
| Distinct | 2960 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 2528 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 786.9573 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 347 |
| median | 601 |
| Q3 | 985 |
| 95-th percentile | 2126 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 638 |
Descriptive statistics
| Standard deviation | 653.02901 |
|---|---|
| Coefficient of variation (CV) | 0.82981504 |
| Kurtosis | 4.9175956 |
| Mean | 786.9573 |
| Median Absolute Deviation (MAD) | 296 |
| Skewness | 2.0100931 |
| Sum | 91213073 |
| Variance | 426446.89 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 710 | 0.6% |
| 1893 | 667 | 0.6% |
| 348 | 644 | 0.5% |
| 903 | 594 | 0.5% |
| 245 | 584 | 0.5% |
| 492 | 577 | 0.5% |
| 366 | 534 | 0.5% |
| 236 | 516 | 0.4% |
| 340 | 484 | 0.4% |
| 919 | 441 | 0.4% |
| Other values (2950) | 110155 | |
| (Missing) | 2528 | 2.1% |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
MISSING 
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2528 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2078495 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7195193 |
|---|---|
| Coefficient of variation (CV) | 0.77882088 |
| Kurtosis | 4.8052032 |
| Mean | 2.2078495 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9057908 |
| Sum | 255903 |
| Variance | 2.9567465 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58542 | |
| 2 | 22896 | 19.3% |
| 3 | 12920 | 10.9% |
| 4 | 8830 | 7.5% |
| 5 | 5585 | 4.7% |
| 6 | 3935 | 3.3% |
| 7 | 1556 | 1.3% |
| 8 | 772 | 0.7% |
| 10 | 353 | 0.3% |
| 9 | 318 | 0.3% |
| Other values (9) | 199 | 0.2% |
| (Missing) | 2528 | 2.1% |
| Value | Count | Frequency (%) |
| 1 | 58542 | |
| 2 | 22896 | 19.3% |
| 3 | 12920 | 10.9% |
| 4 | 8830 | 7.5% |
| 5 | 5585 | 4.7% |
| 6 | 3935 | 3.3% |
| 7 | 1556 | 1.3% |
| 8 | 772 | 0.7% |
| 9 | 318 | 0.3% |
| 10 | 353 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 353 |
product_weight_g
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2204 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 850 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2114.2811 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3788.754 |
|---|---|
| Coefficient of variation (CV) | 1.7919822 |
| Kurtosis | 16.00722 |
| Mean | 2114.2811 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5812411 |
| Sum | 2.4860562 × 108 |
| Variance | 14354657 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 7051 | 6.0% |
| 150 | 5391 | 4.6% |
| 250 | 4702 | 4.0% |
| 300 | 4419 | 3.7% |
| 400 | 3750 | 3.2% |
| 100 | 3628 | 3.1% |
| 350 | 3264 | 2.8% |
| 500 | 2836 | 2.4% |
| 600 | 2822 | 2.4% |
| 700 | 2131 | 1.8% |
| Other values (2194) | 77590 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 988 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 302 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 850 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.256872 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.190874 |
|---|---|
| Coefficient of variation (CV) | 0.53511393 |
| Kurtosis | 3.6874379 |
| Mean | 30.256872 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7478347 |
| Sum | 3557724 |
| Variance | 262.14439 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 18274 | 15.4% |
| 20 | 10918 | 9.2% |
| 30 | 7907 | 6.7% |
| 17 | 6177 | 5.2% |
| 18 | 5883 | 5.0% |
| 19 | 4863 | 4.1% |
| 25 | 4833 | 4.1% |
| 40 | 4306 | 3.6% |
| 22 | 3971 | 3.4% |
| 50 | 3149 | 2.7% |
| Other values (89) | 47303 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 138 | 0.1% |
| 15 | 218 | 0.2% |
| 16 | 18274 |
| Value | Count | Frequency (%) |
| 105 | 334 | |
| 104 | 35 | < 0.1% |
| 103 | 46 | < 0.1% |
| 102 | 59 | < 0.1% |
| 101 | 108 | 0.1% |
| 100 | 426 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 850 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.63029 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.45878 |
|---|---|
| Coefficient of variation (CV) | 0.8092932 |
| Kurtosis | 7.2720955 |
| Mean | 16.63029 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2376777 |
| Sum | 1955456 |
| Variance | 181.13877 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10296 | 8.7% |
| 20 | 6891 | 5.8% |
| 15 | 6839 | 5.8% |
| 12 | 6486 | 5.5% |
| 11 | 6378 | 5.4% |
| 2 | 5213 | 4.4% |
| 4 | 4881 | 4.1% |
| 8 | 4826 | 4.1% |
| 16 | 4742 | 4.0% |
| 5 | 4741 | 4.0% |
| Other values (92) | 56291 |
| Value | Count | Frequency (%) |
| 2 | 5213 | |
| 3 | 2809 | 2.4% |
| 4 | 4881 | |
| 5 | 4741 | |
| 6 | 3553 | 3.0% |
| 7 | 4376 | |
| 8 | 4826 | |
| 9 | 3371 | 2.8% |
| 10 | 10296 | |
| 11 | 6378 |
| Value | Count | Frequency (%) |
| 105 | 138 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 43 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 850 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.068394 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.748372 |
|---|---|
| Coefficient of variation (CV) | 0.50928437 |
| Kurtosis | 4.5712383 |
| Mean | 23.068394 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.7102323 |
| Sum | 2712474 |
| Variance | 138.02426 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12650 | 10.7% |
| 11 | 11083 | 9.4% |
| 15 | 9316 | 7.9% |
| 16 | 8775 | 7.4% |
| 30 | 7988 | 6.7% |
| 12 | 5684 | 4.8% |
| 13 | 5456 | 4.6% |
| 14 | 4807 | 4.1% |
| 18 | 4160 | 3.5% |
| 40 | 4130 | 3.5% |
| Other values (85) | 43535 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 11083 | |
| 12 | 5684 | |
| 13 | 5456 | |
| 14 | 4807 | |
| 15 | 9316 |
| Value | Count | Frequency (%) |
| 118 | 8 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
product_category
Text
MISSING 
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2553 |
| Missing (%) | 2.2% |
| Memory size | 5.8 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 12.981162 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1504270 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | office_furniture |
|---|---|
| 2nd row | housewares |
| 3rd row | office_furniture |
| 4th row | office_furniture |
| 5th row | home_confort |
| Value | Count | Frequency (%) |
| bed_bath_table | 11823 | 10.2% |
| health_beauty | 9975 | 8.6% |
| sports_leisure | 8945 | 7.7% |
| furniture_decor | 8744 | 7.5% |
| computers_accessories | 8082 | 7.0% |
| housewares | 7355 | 6.3% |
| watches_gifts | 6201 | 5.4% |
| telephony | 4721 | 4.1% |
| garden_tools | 4574 | 3.9% |
| auto | 4379 | 3.8% |
| Other values (61) | 41082 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 184021 | |
| s | 141292 | 9.4% |
| t | 132515 | 8.8% |
| o | 111308 | 7.4% |
| r | 105097 | 7.0% |
| a | 101696 | 6.8% |
| _ | 101427 | 6.7% |
| u | 77730 | 5.2% |
| c | 72030 | 4.8% |
| i | 62939 | 4.2% |
| Other values (15) | 414215 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1402544 | |
| Connector Punctuation | 101427 | 6.7% |
| Decimal Number | 299 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 184021 | |
| s | 141292 | 10.1% |
| t | 132515 | 9.4% |
| o | 111308 | 7.9% |
| r | 105097 | 7.5% |
| a | 101696 | 7.3% |
| u | 77730 | 5.5% |
| c | 72030 | 5.1% |
| i | 62939 | 4.5% |
| h | 59263 | 4.2% |
| Other values (13) | 354653 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 101427 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 299 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1402544 | |
| Common | 101726 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 184021 | |
| s | 141292 | 10.1% |
| t | 132515 | 9.4% |
| o | 111308 | 7.9% |
| r | 105097 | 7.5% |
| a | 101696 | 7.3% |
| u | 77730 | 5.5% |
| c | 72030 | 5.1% |
| i | 62939 | 4.5% |
| h | 59263 | 4.2% |
| Other values (13) | 354653 |
Common
| Value | Count | Frequency (%) |
| _ | 101427 | |
| 2 | 299 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1504270 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 184021 | |
| s | 141292 | 9.4% |
| t | 132515 | 8.8% |
| o | 111308 | 7.4% |
| r | 105097 | 7.0% |
| a | 101696 | 6.8% |
| _ | 101427 | 6.7% |
| u | 77730 | 5.2% |
| c | 72030 | 4.8% |
| i | 62939 | 4.2% |
| Other values (15) | 414215 |
seller_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2246 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24442.886 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2972 |
| Q1 | 6429 |
| median | 13660 |
| Q3 | 28035 |
| 95-th percentile | 88316 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 21606 |
Descriptive statistics
| Standard deviation | 27573.803 |
|---|---|
| Coefficient of variation (CV) | 1.1280911 |
| Kurtosis | 0.93603424 |
| Mean | 24442.886 |
| Median Absolute Deviation (MAD) | 8130 |
| Skewness | 1.5556839 |
| Sum | 2.8745812 × 109 |
| Variance | 7.6031461 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 8242 | 7.0% |
| 5849 | 2137 | 1.8% |
| 15025 | 2089 | 1.8% |
| 9015 | 1853 | 1.6% |
| 13405 | 1655 | 1.4% |
| 4782 | 1547 | 1.3% |
| 8577 | 1545 | 1.3% |
| 3204 | 1462 | 1.2% |
| 4160 | 1267 | 1.1% |
| 13232 | 1254 | 1.1% |
| Other values (2236) | 94553 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 41 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 323 | |
| 1031 | 129 | 0.1% |
| 1035 | 18 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 24 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 61 | |
| 99300 | 2 | < 0.1% |
| 98975 | 22 | < 0.1% |
| 98920 | 2 | < 0.1% |
| 98910 | 13 | < 0.1% |
| 98803 | 64 | |
| 98780 | 4 | < 0.1% |
seller_city
Text
| Distinct | 611 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Memory size | 5.8 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 10.103466 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1188208 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 9 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | itaquaquecetuba |
|---|---|
| 2nd row | itajai |
| 3rd row | itaquaquecetuba |
| 4th row | itaquaquecetuba |
| 5th row | ibitinga |
| Value | Count | Frequency (%) |
| sao | 36194 | 17.9% |
| paulo | 29438 | 14.6% |
| ibitinga | 8242 | 4.1% |
| rio | 5910 | 2.9% |
| do | 5505 | 2.7% |
| preto | 5497 | 2.7% |
| de | 4181 | 2.1% |
| jose | 4064 | 2.0% |
| santo | 3214 | 1.6% |
| curitiba | 3137 | 1.6% |
| Other values (640) | 96723 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 197604 | |
| o | 145500 | |
| i | 101338 | 8.5% |
| 84561 | 7.1% | |
| r | 77771 | 6.5% |
| s | 75800 | 6.4% |
| e | 63824 | 5.4% |
| u | 62616 | 5.3% |
| p | 58126 | 4.9% |
| l | 56675 | 4.8% |
| Other values (31) | 264393 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1102430 | |
| Space Separator | 84561 | 7.1% |
| Other Punctuation | 612 | 0.1% |
| Modifier Symbol | 369 | < 0.1% |
| Dash Punctuation | 164 | < 0.1% |
| Close Punctuation | 31 | < 0.1% |
| Open Punctuation | 31 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Nonspacing Mark | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 197604 | |
| o | 145500 | |
| i | 101338 | |
| r | 77771 | 7.1% |
| s | 75800 | 6.9% |
| e | 63824 | 5.8% |
| u | 62616 | 5.7% |
| p | 58126 | 5.3% |
| l | 56675 | 5.1% |
| t | 46959 | 4.3% |
| Other values (14) | 216217 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 345 | |
| / | 141 | |
| . | 76 | 12.4% |
| @ | 38 | 6.2% |
| \ | 6 | 1.0% |
| , | 6 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2 | |
| 2 | 2 | |
| 5 | 2 | |
| 0 | 1 | |
| 8 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 84561 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 369 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 164 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 31 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 31 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1102430 | |
| Common | 85776 | 7.2% |
| Inherited | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 197604 | |
| o | 145500 | |
| i | 101338 | |
| r | 77771 | 7.1% |
| s | 75800 | 6.9% |
| e | 63824 | 5.8% |
| u | 62616 | 5.7% |
| p | 58126 | 5.3% |
| l | 56675 | 5.1% |
| t | 46959 | 4.3% |
| Other values (14) | 216217 |
Common
| Value | Count | Frequency (%) |
| 84561 | ||
| ´ | 369 | 0.4% |
| ' | 345 | 0.4% |
| - | 164 | 0.2% |
| / | 141 | 0.2% |
| . | 76 | 0.1% |
| @ | 38 | < 0.1% |
| ) | 31 | < 0.1% |
| ( | 31 | < 0.1% |
| \ | 6 | < 0.1% |
| Other values (6) | 14 | < 0.1% |
Inherited
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1187837 | |
| None | 369 | < 0.1% |
| Diacriticals | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 197604 | |
| o | 145500 | |
| i | 101338 | 8.5% |
| 84561 | 7.1% | |
| r | 77771 | 6.5% |
| s | 75800 | 6.4% |
| e | 63824 | 5.4% |
| u | 62616 | 5.3% |
| p | 58126 | 4.9% |
| l | 56675 | 4.8% |
| Other values (29) | 264022 |
None
| Value | Count | Frequency (%) |
| ´ | 369 |
Diacriticals
| Value | Count | Frequency (%) |
| ̃ | 2 |
seller_state
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 830 |
| Missing (%) | 0.7% |
| Memory size | 5.8 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 5017 |
| SC | 4257 |
| Other values (18) | 6199 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 235208 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SC |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 83854 | |
| MG | 9260 | 7.8% |
| PR | 9017 | 7.6% |
| RJ | 5017 | 4.2% |
| SC | 4257 | 3.6% |
| RS | 2283 | 1.9% |
| DF | 947 | 0.8% |
| BA | 698 | 0.6% |
| GO | 549 | 0.5% |
| PE | 465 | 0.4% |
| Other values (13) | 1257 | 1.1% |
| (Missing) | 830 | 0.7% |
Length
| Value | Count | Frequency (%) |
| sp | 83854 | |
| mg | 9260 | 7.9% |
| pr | 9017 | 7.7% |
| rj | 5017 | 4.3% |
| sc | 4257 | 3.6% |
| rs | 2283 | 1.9% |
| df | 947 | 0.8% |
| ba | 698 | 0.6% |
| go | 549 | 0.5% |
| pe | 465 | 0.4% |
| Other values (13) | 1257 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 93400 | |
| S | 90854 | |
| R | 16387 | 7.0% |
| M | 9879 | 4.2% |
| G | 9809 | 4.2% |
| J | 5017 | 2.1% |
| C | 4361 | 1.9% |
| A | 1119 | 0.5% |
| E | 968 | 0.4% |
| D | 947 | 0.4% |
| Other values (6) | 2467 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 235208 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 93400 | |
| S | 90854 | |
| R | 16387 | 7.0% |
| M | 9879 | 4.2% |
| G | 9809 | 4.2% |
| J | 5017 | 2.1% |
| C | 4361 | 1.9% |
| A | 1119 | 0.5% |
| E | 968 | 0.4% |
| D | 947 | 0.4% |
| Other values (6) | 2467 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 235208 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 93400 | |
| S | 90854 | |
| R | 16387 | 7.0% |
| M | 9879 | 4.2% |
| G | 9809 | 4.2% |
| J | 5017 | 2.1% |
| C | 4361 | 1.9% |
| A | 1119 | 0.5% |
| E | 968 | 0.4% |
| D | 947 | 0.4% |
| Other values (6) | 2467 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 235208 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 93400 | |
| S | 90854 | |
| R | 16387 | 7.0% |
| M | 9879 | 4.2% |
| G | 9809 | 4.2% |
| J | 5017 | 2.1% |
| C | 4361 | 1.9% |
| A | 1119 | 0.5% |
| E | 968 | 0.4% |
| D | 947 | 0.4% |
| Other values (6) | 2467 | 1.0% |
order_purchase_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| 2018 | |
|---|---|
| 2017 | |
| 2016 | 405 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 473736 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2018 |
| 4th row | 2018 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 63924 | |
| 2017 | 54105 | |
| 2016 | 405 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2018 | 63924 | |
| 2017 | 54105 | |
| 2016 | 405 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 118434 | |
| 0 | 118434 | |
| 1 | 118434 | |
| 8 | 63924 | |
| 7 | 54105 | |
| 6 | 405 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 473736 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 118434 | |
| 0 | 118434 | |
| 1 | 118434 | |
| 8 | 63924 | |
| 7 | 54105 | |
| 6 | 405 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 473736 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 118434 | |
| 0 | 118434 | |
| 1 | 118434 | |
| 8 | 63924 | |
| 7 | 54105 | |
| 6 | 405 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 473736 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 118434 | |
| 0 | 118434 | |
| 1 | 118434 | |
| 8 | 63924 | |
| 7 | 54105 | |
| 6 | 405 | 0.1% |
order_purchase_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.0337234 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2318054 |
|---|---|
| Coefficient of variation (CV) | 0.53562372 |
| Kurtosis | -0.98261973 |
| Mean | 6.0337234 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.20436226 |
| Sum | 714598 |
| Variance | 10.444566 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 12745 | |
| 5 | 12684 | |
| 7 | 12253 | |
| 3 | 11790 | |
| 6 | 11209 | |
| 4 | 11135 | |
| 2 | 10068 | |
| 1 | 9614 | |
| 11 | 9111 | |
| 12 | 6617 | |
| Other values (2) | 11208 |
| Value | Count | Frequency (%) |
| 1 | 9614 | |
| 2 | 10068 | |
| 3 | 11790 | |
| 4 | 11135 | |
| 5 | 12684 | |
| 6 | 11209 | |
| 7 | 12253 | |
| 8 | 12745 | |
| 9 | 5172 | |
| 10 | 6036 |
| Value | Count | Frequency (%) |
| 12 | 6617 | |
| 11 | 9111 | |
| 10 | 6036 | |
| 9 | 5172 | |
| 8 | 12745 | |
| 7 | 12253 | |
| 6 | 11209 | |
| 5 | 12684 | |
| 4 | 11135 | |
| 3 | 11790 |
order_purchase_day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.547393 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.6680764 |
|---|---|
| Coefficient of variation (CV) | 0.55752602 |
| Kurtosis | -1.1787215 |
| Mean | 15.547393 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.017350748 |
| Sum | 1841340 |
| Variance | 75.135549 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 4600 | 3.9% |
| 16 | 4286 | 3.6% |
| 15 | 4164 | 3.5% |
| 5 | 4148 | 3.5% |
| 6 | 4120 | 3.5% |
| 18 | 4073 | 3.4% |
| 4 | 4034 | 3.4% |
| 19 | 4030 | 3.4% |
| 7 | 4021 | 3.4% |
| 26 | 3983 | 3.4% |
| Other values (21) | 76975 |
| Value | Count | Frequency (%) |
| 1 | 3680 | |
| 2 | 3844 | |
| 3 | 3824 | |
| 4 | 4034 | |
| 5 | 4148 | |
| 6 | 4120 | |
| 7 | 4021 | |
| 8 | 3982 | |
| 9 | 3863 | |
| 10 | 3731 |
| Value | Count | Frequency (%) |
| 31 | 1986 | |
| 30 | 3021 | |
| 29 | 3095 | |
| 28 | 3558 | |
| 27 | 3810 | |
| 26 | 3983 | |
| 25 | 3937 | |
| 24 | 4600 | |
| 23 | 3799 | |
| 22 | 3825 |
order_purchase_hour
Real number (ℝ)
ZEROS 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.75605 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 2910 |
| Zeros (%) | 2.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 11 |
| median | 15 |
| Q3 | 19 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.3272401 |
|---|---|
| Coefficient of variation (CV) | 0.36102075 |
| Kurtosis | 0.19316826 |
| Mean | 14.75605 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.60239495 |
| Sum | 1747618 |
| Variance | 28.379487 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 8039 | 6.8% |
| 14 | 7944 | 6.7% |
| 11 | 7821 | 6.6% |
| 13 | 7729 | 6.5% |
| 15 | 7669 | 6.5% |
| 10 | 7392 | 6.2% |
| 17 | 7302 | 6.2% |
| 20 | 7298 | 6.2% |
| 21 | 7290 | 6.2% |
| 12 | 7236 | 6.1% |
| Other values (14) | 42714 |
| Value | Count | Frequency (%) |
| 0 | 2910 | |
| 1 | 1369 | 1.2% |
| 2 | 616 | 0.5% |
| 3 | 326 | 0.3% |
| 4 | 254 | 0.2% |
| 5 | 226 | 0.2% |
| 6 | 571 | 0.5% |
| 7 | 1428 | 1.2% |
| 8 | 3523 | |
| 9 | 5694 |
| Value | Count | Frequency (%) |
| 23 | 4909 | |
| 22 | 6947 | |
| 21 | 7290 | |
| 20 | 7298 | |
| 19 | 7043 | |
| 18 | 6898 | |
| 17 | 7302 | |
| 16 | 8039 | |
| 15 | 7669 | |
| 14 | 7944 |
| customer_state | customer_zip_code_prefix | freight_value | order_item_id | order_purchase_day | order_purchase_hour | order_purchase_month | order_purchase_year | order_status | payment_installments | payment_sequential | payment_type | payment_value | price | product_description_lenght | product_height_cm | product_length_cm | product_name_lenght | product_photos_qty | product_weight_g | product_width_cm | seller_state | seller_zip_code_prefix | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_state | 1.000 | 0.896 | 0.085 | 0.013 | 0.011 | 0.020 | 0.021 | 0.042 | 0.026 | 0.032 | 0.026 | 0.033 | 0.029 | 0.020 | 0.027 | 0.019 | 0.017 | 0.013 | 0.014 | 0.028 | 0.016 | 0.054 | 0.069 |
| customer_zip_code_prefix | 0.896 | 1.000 | 0.466 | -0.009 | -0.010 | 0.012 | -0.007 | 0.036 | 0.022 | 0.069 | -0.008 | 0.029 | 0.106 | 0.070 | 0.031 | 0.019 | 0.009 | 0.015 | 0.026 | 0.026 | -0.002 | 0.065 | 0.060 |
| freight_value | 0.085 | 0.466 | 1.000 | -0.055 | -0.017 | 0.007 | -0.003 | 0.028 | 0.015 | 0.191 | 0.018 | 0.009 | 0.423 | 0.434 | 0.117 | 0.285 | 0.284 | 0.033 | 0.011 | 0.449 | 0.276 | 0.048 | 0.257 |
| order_item_id | 0.013 | -0.009 | -0.055 | 1.000 | 0.014 | -0.015 | 0.001 | 0.007 | 0.002 | 0.060 | -0.007 | 0.021 | 0.256 | -0.116 | -0.031 | 0.018 | 0.006 | -0.021 | -0.064 | -0.000 | -0.004 | 0.000 | -0.012 |
| order_purchase_day | 0.011 | -0.010 | -0.017 | 0.014 | 1.000 | -0.013 | -0.002 | 0.083 | 0.010 | -0.001 | -0.003 | 0.007 | -0.009 | -0.021 | -0.004 | -0.004 | -0.009 | 0.009 | 0.000 | -0.007 | -0.002 | 0.015 | -0.004 |
| order_purchase_hour | 0.020 | 0.012 | 0.007 | -0.015 | -0.013 | 1.000 | -0.002 | 0.018 | 0.010 | 0.030 | 0.013 | 0.037 | -0.006 | 0.009 | -0.009 | 0.002 | 0.009 | 0.001 | 0.005 | 0.016 | 0.011 | 0.010 | -0.004 |
| order_purchase_month | 0.021 | -0.007 | -0.003 | 0.001 | -0.002 | -0.002 | 1.000 | 0.461 | 0.024 | 0.027 | 0.001 | 0.030 | 0.001 | 0.002 | -0.018 | 0.020 | 0.002 | 0.014 | 0.026 | 0.009 | 0.015 | 0.039 | 0.009 |
| order_purchase_year | 0.042 | 0.036 | 0.028 | 0.007 | 0.083 | 0.018 | 0.461 | 1.000 | 0.067 | 0.048 | 0.030 | 0.041 | 0.008 | 0.000 | 0.049 | 0.041 | 0.050 | 0.082 | 0.029 | 0.015 | 0.047 | 0.084 | 0.065 |
| order_status | 0.026 | 0.022 | 0.015 | 0.002 | 0.010 | 0.010 | 0.024 | 0.067 | 1.000 | 0.005 | 0.026 | 0.037 | 0.015 | 0.014 | 0.016 | 0.015 | 0.014 | 0.019 | 0.013 | 0.011 | 0.004 | 0.029 | 0.013 |
| payment_installments | 0.032 | 0.069 | 0.191 | 0.060 | -0.001 | 0.030 | 0.027 | 0.048 | 0.005 | 1.000 | -0.177 | 0.236 | 0.396 | 0.317 | 0.033 | 0.106 | 0.108 | 0.016 | -0.002 | 0.198 | 0.124 | 0.033 | 0.066 |
| payment_sequential | 0.026 | -0.008 | 0.018 | -0.007 | -0.003 | 0.013 | 0.001 | 0.030 | 0.026 | -0.177 | 1.000 | 0.198 | -0.214 | -0.006 | -0.013 | 0.013 | 0.034 | -0.003 | -0.005 | 0.030 | 0.028 | 0.016 | 0.007 |
| payment_type | 0.033 | 0.029 | 0.009 | 0.021 | 0.007 | 0.037 | 0.030 | 0.041 | 0.037 | 0.236 | 0.198 | 1.000 | 0.018 | 0.015 | 0.020 | 0.015 | 0.022 | 0.010 | 0.004 | 0.018 | 0.020 | 0.021 | 0.018 |
| payment_value | 0.029 | 0.106 | 0.423 | 0.256 | -0.009 | -0.006 | 0.001 | 0.008 | 0.015 | 0.396 | -0.214 | 0.018 | 1.000 | 0.790 | 0.169 | 0.305 | 0.228 | 0.024 | -0.011 | 0.449 | 0.232 | 0.036 | 0.160 |
| price | 0.020 | 0.070 | 0.434 | -0.116 | -0.021 | 0.009 | 0.002 | 0.000 | 0.014 | 0.317 | -0.006 | 0.015 | 0.790 | 1.000 | 0.211 | 0.328 | 0.266 | 0.042 | 0.029 | 0.514 | 0.271 | 0.052 | 0.176 |
| product_description_lenght | 0.027 | 0.031 | 0.117 | -0.031 | -0.004 | -0.009 | -0.018 | 0.049 | 0.016 | 0.033 | -0.013 | 0.020 | 0.169 | 0.211 | 1.000 | 0.134 | -0.020 | 0.073 | 0.110 | 0.095 | -0.080 | 0.112 | 0.002 |
| product_height_cm | 0.019 | 0.019 | 0.285 | 0.018 | -0.004 | 0.002 | 0.020 | 0.041 | 0.015 | 0.106 | 0.013 | 0.015 | 0.305 | 0.328 | 0.134 | 1.000 | 0.250 | -0.057 | -0.079 | 0.533 | 0.340 | 0.065 | 0.050 |
| product_length_cm | 0.017 | 0.009 | 0.284 | 0.006 | -0.009 | 0.009 | 0.002 | 0.050 | 0.014 | 0.108 | 0.034 | 0.022 | 0.228 | 0.266 | -0.020 | 0.250 | 1.000 | 0.060 | 0.006 | 0.619 | 0.632 | 0.084 | 0.067 |
| product_name_lenght | 0.013 | 0.015 | 0.033 | -0.021 | 0.009 | 0.001 | 0.014 | 0.082 | 0.019 | 0.016 | -0.003 | 0.010 | 0.024 | 0.042 | 0.073 | -0.057 | 0.060 | 1.000 | 0.163 | 0.075 | 0.065 | 0.070 | 0.009 |
| product_photos_qty | 0.014 | 0.026 | 0.011 | -0.064 | 0.000 | 0.005 | 0.026 | 0.029 | 0.013 | -0.002 | -0.005 | 0.004 | -0.011 | 0.029 | 0.110 | -0.079 | 0.006 | 0.163 | 1.000 | 0.004 | -0.014 | 0.040 | -0.078 |
| product_weight_g | 0.028 | 0.026 | 0.449 | -0.000 | -0.007 | 0.016 | 0.009 | 0.015 | 0.011 | 0.198 | 0.030 | 0.018 | 0.449 | 0.514 | 0.095 | 0.533 | 0.619 | 0.075 | 0.004 | 1.000 | 0.621 | 0.078 | 0.097 |
| product_width_cm | 0.016 | -0.002 | 0.276 | -0.004 | -0.002 | 0.011 | 0.015 | 0.047 | 0.004 | 0.124 | 0.028 | 0.020 | 0.232 | 0.271 | -0.080 | 0.340 | 0.632 | 0.065 | -0.014 | 0.621 | 1.000 | 0.057 | 0.078 |
| seller_state | 0.054 | 0.065 | 0.048 | 0.000 | 0.015 | 0.010 | 0.039 | 0.084 | 0.029 | 0.033 | 0.016 | 0.021 | 0.036 | 0.052 | 0.112 | 0.065 | 0.084 | 0.070 | 0.040 | 0.078 | 0.057 | 1.000 | 0.920 |
| seller_zip_code_prefix | 0.069 | 0.060 | 0.257 | -0.012 | -0.004 | -0.004 | 0.009 | 0.065 | 0.013 | 0.066 | 0.007 | 0.018 | 0.160 | 0.176 | 0.002 | 0.050 | 0.067 | 0.009 | -0.078 | 0.097 | 0.078 | 0.920 | 1.000 |
| customer_id | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category | seller_zip_code_prefix | seller_city | seller_state | order_purchase_year | order_purchase_month | order_purchase_day | order_purchase_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 06b8999e2fba1a1fbc88172c00ba8bc7 | 861eff4711a542e4b93843c6dd7febb0 | 14409 | franca | SP | 00e7ee1b050b8499577073aeb2a297a1 | delivered | 2017-05-16 15:05:35 | 2017-05-16 15:22:12 | 2017-05-23 10:47:57 | 2017-05-25 10:35:35 | 2017-06-05 00:00:00 | 1.0 | a9516a079e37a9c9c36b9b78b10169e8 | 7c67e1448b00f6e969d365cea6b010ab | 2017-05-22 15:22:12 | 124.99 | 21.88 | 1.0 | credit_card | 2.0 | 146.87 | 41.0 | 1141.0 | 1.0 | 8683.0 | 54.0 | 64.0 | 31.0 | office_furniture | 8577.0 | itaquaquecetuba | SP | 2017 | 5 | 16 | 15 |
| 1 | 18955e83d337fd6b2def6b18a428ac77 | 290c77bc529b7ac935b93aa66c333dc3 | 9790 | sao bernardo do campo | SP | 29150127e6685892b6eab3eec79f59c7 | delivered | 2018-01-12 20:48:24 | 2018-01-12 20:58:32 | 2018-01-15 17:14:59 | 2018-01-29 12:41:19 | 2018-02-06 00:00:00 | 1.0 | 4aa6014eceb682077f9dc4bffebc05b0 | b8bc237ba3788b23da09c0f1f3a3288c | 2018-01-18 20:58:32 | 289.00 | 46.48 | 1.0 | credit_card | 8.0 | 335.48 | 43.0 | 1002.0 | 3.0 | 10150.0 | 89.0 | 15.0 | 40.0 | housewares | 88303.0 | itajai | SC | 2018 | 1 | 12 | 20 |
| 2 | 4e7b3e00288586ebd08712fdd0374a03 | 060e732b5b29e8181a18229c7b0b2b5e | 1151 | sao paulo | SP | b2059ed67ce144a36e2aa97d2c9e9ad2 | delivered | 2018-05-19 16:07:45 | 2018-05-20 16:19:10 | 2018-06-11 14:31:00 | 2018-06-14 17:58:51 | 2018-06-13 00:00:00 | 1.0 | bd07b66896d6f1494f5b86251848ced7 | 7c67e1448b00f6e969d365cea6b010ab | 2018-06-05 16:19:10 | 139.94 | 17.79 | 1.0 | credit_card | 7.0 | 157.73 | 55.0 | 955.0 | 1.0 | 8267.0 | 52.0 | 52.0 | 17.0 | office_furniture | 8577.0 | itaquaquecetuba | SP | 2018 | 5 | 19 | 16 |
| 3 | b2b6027bc5c5109e529d4dc6358b12c3 | 259dac757896d24d7702b9acbbff3f3c | 8775 | mogi das cruzes | SP | 951670f92359f4fe4a63112aa7306eba | delivered | 2018-03-13 16:06:38 | 2018-03-13 17:29:19 | 2018-03-27 23:22:42 | 2018-03-28 16:04:25 | 2018-04-10 00:00:00 | 1.0 | a5647c44af977b148e0a3a4751a09e2e | 7c67e1448b00f6e969d365cea6b010ab | 2018-03-27 16:31:16 | 149.94 | 23.36 | 1.0 | credit_card | 1.0 | 173.30 | 48.0 | 1066.0 | 1.0 | 12160.0 | 56.0 | 51.0 | 28.0 | office_furniture | 8577.0 | itaquaquecetuba | SP | 2018 | 3 | 13 | 16 |
| 4 | 4f2d8ab171c80ec8364f7c12e35b23ad | 345ecd01c38d18a9036ed96c73b8d066 | 13056 | campinas | SP | 6b7d50bd145f6fc7f33cebabd7e49d0f | delivered | 2018-07-29 09:51:30 | 2018-07-29 10:10:09 | 2018-07-30 15:16:00 | 2018-08-09 20:55:48 | 2018-08-15 00:00:00 | 1.0 | 9391a573abe00141c56e38d84d7d5b3b | 4a3ca9315b744ce9f8e9374361493884 | 2018-07-31 10:10:09 | 230.00 | 22.25 | 1.0 | credit_card | 8.0 | 252.25 | 61.0 | 407.0 | 1.0 | 5200.0 | 45.0 | 15.0 | 35.0 | home_confort | 14940.0 | ibitinga | SP | 2018 | 7 | 29 | 9 |
| 5 | 879864dab9bc3047522c92c82e1212b8 | 4c93744516667ad3b8f1fb645a3116a4 | 89254 | jaragua do sul | SC | 5741ea1f91b5fbab2bd2dc653a5b5099 | delivered | 2017-09-14 18:14:31 | 2017-09-14 18:25:11 | 2017-09-18 21:27:40 | 2017-09-28 17:32:43 | 2017-10-04 00:00:00 | 1.0 | 0be701e03657109a8a4d5168122777fb | 8f2ce03f928b567e3d56181ae20ae952 | 2017-09-20 18:25:11 | 259.90 | 22.31 | 1.0 | debit_card | 1.0 | 282.21 | 32.0 | 282.0 | 2.0 | 4450.0 | 60.0 | 15.0 | 15.0 | sports_leisure | 5141.0 | pirituba | SP | 2017 | 9 | 14 | 18 |
| 6 | fd826e7cf63160e536e0908c76c3f441 | addec96d2e059c80c30fe6871d30d177 | 4534 | sao paulo | SP | 36e694cf4cbc2a4803200c35e84abdc4 | delivered | 2018-02-19 14:38:35 | 2018-02-19 14:50:37 | 2018-02-20 00:03:39 | 2018-02-20 16:25:51 | 2018-03-05 00:00:00 | 1.0 | b5466db4cecf95c3c1be0ba32538ce1a | 9f505651f4a6abe901a56cdc21508025 | 2018-02-23 14:50:37 | 14.99 | 7.78 | 1.0 | credit_card | 1.0 | 22.77 | 37.0 | 322.0 | 3.0 | 100.0 | 16.0 | 3.0 | 13.0 | computers_accessories | 4102.0 | sao paulo | SP | 2018 | 2 | 19 | 14 |
| 7 | 5e274e7a0c3809e14aba7ad5aae0d407 | 57b2a98a409812fe9618067b6b8ebe4f | 35182 | timoteo | MG | 1093c8304c7a003280dd34598194913d | delivered | 2017-11-16 19:29:02 | 2017-11-16 19:55:41 | 2017-11-22 16:46:33 | 2017-11-27 12:44:36 | 2017-12-08 00:00:00 | 1.0 | 124f74f703e88efe001a10bfa718b6ff | 2a7dc43cecabf23403078e2188437d1d | 2017-11-22 19:55:41 | 19.90 | 16.11 | 1.0 | credit_card | 3.0 | 36.01 | NaN | NaN | NaN | 250.0 | 15.0 | 8.0 | 20.0 | NaN | 4142.0 | sao paulo | SP | 2017 | 11 | 16 | 19 |
| 8 | 5adf08e34b2e993982a47070956c5c65 | 1175e95fb47ddff9de6b2b06188f7e0d | 81560 | curitiba | PR | 1ebeea841c590e86a14a0d7a48e7d062 | delivered | 2018-01-18 12:35:44 | 2018-01-18 12:56:32 | 2018-01-18 23:25:35 | 2018-01-26 15:17:57 | 2018-02-20 00:00:00 | 1.0 | 08401f48b67a852d06105725c3013eff | 95e03ca3d4146e4011985981aeb959b9 | 2018-01-30 12:56:32 | 25.00 | 14.10 | 1.0 | debit_card | 1.0 | 39.10 | 58.0 | 739.0 | 5.0 | 350.0 | 28.0 | 10.0 | 12.0 | toys | 21210.0 | rio de janeiro | RJ | 2018 | 1 | 18 | 12 |
| 9 | 4b7139f34592b3a31687243a302fa75b | 9afe194fb833f79e300e37e580171f22 | 30575 | belo horizonte | MG | 7433cbcc783205509d66a5260da5b574 | delivered | 2018-01-08 11:22:34 | 2018-01-08 11:35:27 | 2018-01-11 01:00:40 | 2018-01-13 14:51:55 | 2018-02-05 00:00:00 | 1.0 | 78efe838c04bbc568be034082200ac20 | 0241d4d5d36f10f80c644447315af0bd | 2018-01-12 11:35:27 | 99.90 | 22.57 | 1.0 | credit_card | 1.0 | 122.47 | 57.0 | 272.0 | 1.0 | 2500.0 | 40.0 | 10.0 | 30.0 | furniture_decor | 80330.0 | curitiba | PR | 2018 | 1 | 8 | 11 |
| customer_id | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category | seller_zip_code_prefix | seller_city | seller_state | order_purchase_year | order_purchase_month | order_purchase_day | order_purchase_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118424 | f255d679c7c86c24ef4861320d5b7675 | d111b06b6f3a2add0d2241325f65b5ca | 13500 | rio claro | SP | ca978d2459ea2c5ef6d5fde02be26b9c | delivered | 2018-03-06 09:16:56 | 2018-03-06 09:29:07 | 2018-03-06 18:51:58 | 2018-03-07 20:58:53 | 2018-03-19 00:00:00 | 1.0 | 163da86e86f0089de089399c28c3fcbb | 9f505651f4a6abe901a56cdc21508025 | 2018-03-13 09:29:07 | 99.00 | 9.59 | 1.0 | credit_card | 3.0 | 108.59 | 60.0 | 407.0 | 3.0 | 400.0 | 16.0 | 3.0 | 21.0 | computers_accessories | 4102.0 | sao paulo | SP | 2018 | 3 | 6 | 9 |
| 118425 | 14308d2303a3e2bdf4939b86c46d2679 | e7f8760e2bbd2f1986bebd99596c088e | 66033 | belem | PA | ec3a75fb0ac595e461765d2d854b1d08 | delivered | 2017-03-15 21:04:08 | 2017-03-15 21:04:08 | 2017-03-20 08:34:12 | 2017-04-05 11:07:12 | 2017-04-26 00:00:00 | 1.0 | 6b5af19067eeadc0f331687a79ca656b | bf0045791395e66460eb04749c68672a | 2017-03-28 21:04:08 | 59.90 | 24.42 | 2.0 | voucher | 1.0 | 40.53 | 62.0 | 621.0 | 1.0 | 600.0 | 16.0 | 6.0 | 11.0 | stationery | 4256.0 | sao paulo | SP | 2017 | 3 | 15 | 21 |
| 118426 | 14308d2303a3e2bdf4939b86c46d2679 | e7f8760e2bbd2f1986bebd99596c088e | 66033 | belem | PA | ec3a75fb0ac595e461765d2d854b1d08 | delivered | 2017-03-15 21:04:08 | 2017-03-15 21:04:08 | 2017-03-20 08:34:12 | 2017-04-05 11:07:12 | 2017-04-26 00:00:00 | 1.0 | 6b5af19067eeadc0f331687a79ca656b | bf0045791395e66460eb04749c68672a | 2017-03-28 21:04:08 | 59.90 | 24.42 | 1.0 | voucher | 1.0 | 43.79 | 62.0 | 621.0 | 1.0 | 600.0 | 16.0 | 6.0 | 11.0 | stationery | 4256.0 | sao paulo | SP | 2017 | 3 | 15 | 21 |
| 118427 | f5a0b560f9e9427792a88bec97710212 | b3e53d18a997f27a3ffd16da497eaf58 | 7790 | cajamar | SP | 97d6c1727b0d36b8d04035e35d86f40f | delivered | 2018-05-18 21:42:33 | 2018-05-18 21:55:14 | 2018-06-04 16:03:00 | 2018-06-05 19:33:24 | 2018-06-06 00:00:00 | 1.0 | e0d64dcfaa3b6db5c54ca298ae101d05 | 2eb70248d66e0e3ef83659f71b244378 | 2018-05-29 21:55:14 | 124.90 | 7.74 | 1.0 | credit_card | 1.0 | 132.64 | 35.0 | 514.0 | 2.0 | 4338.0 | 17.0 | 12.0 | 14.0 | watches_gifts | 13101.0 | campinas | SP | 2018 | 5 | 18 | 21 |
| 118428 | 7fe2e80252a9ea476f950ae8f85b0f8f | 4b5820135d360a45552b5163835b1d89 | 35500 | divinopolis | MG | c9aea907527f5d4f5fb44955c18a79fb | delivered | 2017-12-17 23:13:41 | 2017-12-18 00:17:27 | 2017-12-20 18:52:08 | 2018-01-04 13:08:05 | 2018-01-23 00:00:00 | 1.0 | c770c3d5ab511e88a96d387bdb0b6ce0 | e06f09ec0a4aca210779cf1cfc63cf19 | 2018-01-03 00:17:27 | 55.00 | 20.88 | 1.0 | credit_card | 1.0 | 75.88 | 12.0 | 210.0 | 2.0 | 1100.0 | 48.0 | 24.0 | 23.0 | housewares | 4773.0 | sao paulo | SP | 2017 | 12 | 17 | 23 |
| 118429 | 17ddf5dd5d51696bb3d7c6291687be6f | 1a29b476fee25c95fbafc67c5ac95cf8 | 3937 | sao paulo | SP | 6760e20addcf0121e9d58f2f1ff14298 | delivered | 2018-04-07 15:48:17 | 2018-04-07 16:08:45 | 2018-04-11 02:08:36 | 2018-04-13 20:06:37 | 2018-04-25 00:00:00 | 1.0 | ccb4503d9d43d245d3b295d0544f988b | 527801b552d0077ffd170872eb49683b | 2018-04-12 16:08:45 | 74.90 | 13.88 | 1.0 | credit_card | 6.0 | 88.78 | 51.0 | 489.0 | 2.0 | 611.0 | 22.0 | 22.0 | 23.0 | books_general_interest | 17400.0 | garca | SP | 2018 | 4 | 7 | 15 |
| 118430 | e7b71a9017aa05c9a7fd292d714858e8 | d52a67c98be1cf6a5c84435bd38d095d | 6764 | taboao da serra | SP | 9ec0c8947d973db4f4e8dcf1fbfa8f1b | delivered | 2018-04-04 08:20:22 | 2018-04-04 08:35:12 | 2018-04-05 18:42:35 | 2018-04-11 18:54:45 | 2018-04-20 00:00:00 | 1.0 | 9ede6b0570a75a4b9de4f383329f99ee | 3fd1e727ba94cfe122d165e176ce7967 | 2018-04-10 08:35:12 | 114.90 | 14.16 | 1.0 | credit_card | 3.0 | 129.06 | 51.0 | 1193.0 | 1.0 | 1211.0 | 25.0 | 24.0 | 22.0 | sports_leisure | 14802.0 | araraquara | SP | 2018 | 4 | 4 | 8 |
| 118431 | 5e28dfe12db7fb50a4b2f691faecea5e | e9f50caf99f032f0bf3c55141f019d99 | 60115 | fortaleza | CE | fed4434add09a6f332ea398efd656a5c | delivered | 2018-04-08 20:11:50 | 2018-04-08 20:30:03 | 2018-04-09 17:52:17 | 2018-05-09 19:03:15 | 2018-05-02 00:00:00 | 1.0 | 7a5d2e1e131a860ae7d18f6fffa9d689 | d9e7e7778b32987280a6f2cb9a39c57d | 2018-04-12 20:30:03 | 37.00 | 19.04 | 1.0 | credit_card | 5.0 | 56.04 | 60.0 | 575.0 | 1.0 | 870.0 | 25.0 | 20.0 | 18.0 | health_beauty | 3304.0 | sao paulo | SP | 2018 | 4 | 8 | 20 |
| 118432 | 56b18e2166679b8a959d72dd06da27f9 | 73c2643a0a458b49f58cea58833b192e | 92120 | canoas | RS | e31ec91cea1ecf97797787471f98a8c2 | delivered | 2017-11-03 21:08:33 | 2017-11-03 21:31:20 | 2017-11-06 18:24:41 | 2017-11-16 19:58:39 | 2017-12-05 00:00:00 | 1.0 | f819f0c84a64f02d3a5606ca95edd272 | 4869f7a5dfa277a7dca6462dcf3b52b2 | 2017-11-09 21:15:51 | 689.00 | 22.07 | 1.0 | credit_card | 2.0 | 711.07 | 59.0 | 452.0 | 1.0 | 710.0 | 19.0 | 13.0 | 14.0 | watches_gifts | 14840.0 | guariba | SP | 2017 | 11 | 3 | 21 |
| 118433 | 274fa6071e5e17fe303b9748641082c8 | 84732c5050c01db9b23e19ba39899398 | 6703 | cotia | SP | 28db69209a75e59f20ccbb5c36a20b90 | delivered | 2017-12-19 14:27:23 | 2017-12-19 18:50:39 | 2017-12-21 19:17:21 | 2017-12-26 18:42:36 | 2018-01-08 00:00:00 | 1.0 | 017692475c1c954ff597feda05131d73 | 3c7c4a49ec3c6550809089c6a2ca9370 | 2017-12-26 18:50:39 | 13.99 | 7.78 | 1.0 | credit_card | 1.0 | 21.77 | 54.0 | 933.0 | 1.0 | 50.0 | 16.0 | 5.0 | 11.0 | perfumery | 3804.0 | sao paulo | SP | 2017 | 12 | 19 | 14 |